dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005, and 2008 that offers powerful autocompletion and formatting of T-SQL code features.
Besides extending List Members, Complete Word, and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.
Key features:
* Context-based code completion:
dbForge SQL Complete has a feature to offer code completion
lists based on context instead of simply listing object attributes and methods.
*Quick object info:
Essential information about a database object is shown in the popup window when the mouse cursor is over the identifier. For tables users can see column names with data types, additional column properties, primary, unique, and foreign keys. For other objects, the quick info includes object type and an available user description.
* Customizable SQL formatting:
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc.
* Quick parameter info for functions:
When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint.
* Suggesting conditions for JOIN statements:
dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
* Automatic alias generation:
The tool can generate an alias for each table object in the FROM list of SQL document automatically.
* Suggestions of T-SQL statements in procedures and functions:
SQL Complete supports:
- DECLARE statements for local variables, cursor variables, and table definitions;
- cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements;
- context for such control-of-flow as BEGIN...END, GOTO, IF...ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY...CATCH, CASE, RAISERROR.
